package com.lsk.netdisk.file.mappers;

import com.lsk.netdisk.file.model.Space;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface SpaceMapper {
	@Select("select * from space where userID=#{userID}")
	public Space querySpaceInformationByUserId(@Param("userID") Integer userID);
	@Update("update space set used=#{used} where userID=#{userID}")
	public void updateUsedValue(@Param("used") Double used, @Param("userID") Integer userID);
	@Update("update space set total=#{total} where userID=#{userID}")
	public void updateTotalValue(@Param("total") Integer total, @Param("userID") Integer userID);
}
